ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

Base64encode + Base64decode

Encodes and decodes a string, Base64 is used to convert binary data (like ...

SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

CellRead

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

Webapp-ScrollAreas

Allow website to have scroll bars on areas, like a web app Applied in ANmar. ...

VBA Progressbar (Frm73)

Progress bar Frm73 or just simple message Zip file contains .frm and .frx ...

Frm73.zip

Replace Single Quotes

This script will replace single quotes so the data is SQL-safe

ArrayRead + ArraySave

Reading and saving 2 dim data into ANStrArray ANStrArray is a string ...

Create and Write Log File

The subprocedure can be called by any ASP applicaiton/page which needs to ...